package com.ruoyi.domain;

import com.alibaba.excel.annotation.format.NumberFormat;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;
import lombok.Data;

import java.math.BigDecimal;

/**
 * 成本费用表
 *
 * @Author:zzm
 * @Date: 2024/12/04 21:07
 */
@Data
public class LibraryOperationsCost {

    private static final long serialVersionUID = 1L;

    /**
     * 出库仓库
     */
    @Excel(name = "出库仓库")
    private String wareHouse;

    /**
     * 订单编号
     */
    @Excel(name = "订单编号")
    private String orderNo;

    /**
     * 销售平台
     */
    @Excel(name = "销售平台")
    private String salesPlatform;

    /**
     * 提审时间
     */
    @Excel(name = "提审时间")
    private String submissionTime;

    /**
     * 处理时间
     */
    @Excel(name = "处理时间")
    private String processingTime;

    /**
     * 发货时间
     */
    @Excel(name = "发货时间")
    private String deliveryTime;

    /**
     * 收货人
     */
    @Excel(name = "收货人")
    private String consignee;

    /**
     * 国家
     */
    @Excel(name = "国家")
    private String country;

    /**
     * 州/省
     */
    @Excel(name = "州/省")
    private String province;

    /**
     * 城市
     */
    @Excel(name = "城市")
    private String city;

    /**
     * 邮编
     */
    @Excel(name = "邮编")
    private String postalCode;

    /**
     * 分区
     */
    @Excel(name = "分区")
    private String partition;

    /**
     * 包裹长(cm)
     */
    @Excel(name = "包裹长(CM)")
    private BigDecimal length;

    /**
     * 包裹宽(cm)
     */
    @Excel(name = "包裹宽(CM)")
    private BigDecimal width;

    /**
     * 包裹高(cm)
     */
    @Excel(name = "包裹高(CM)")
    private BigDecimal height;

    /**
     * 包裹重量(g)
     */
    @Excel(name = "包裹重量(g)")
    private BigDecimal weight;

    /**
     * 计费重(LB)
     */
    @Excel(name = "计费重(LB)")
    @NumberFormat("#0.00")
    private BigDecimal billingWeight;

    /**
     * SKU数量
     */
    @Excel(name = "SKU数量")
    private BigDecimal SKUNum;

    /**
     * SKU1
     */
    @Excel(name = "SKU1")
    private String SKU1;

    /**
     * SKU1数量
     */
    @Excel(name = "SKU1数量")
    private BigDecimal SKU1Num;

    /**
     * SKU2
     */
    @Excel(name = "SKU2")
    private String SKU2;

    /**
     * SKU2数量
     */
    @Excel(name = "SKU2数量")
    private BigDecimal SKU2Num;

    /**
     * SKU3
     */
    @Excel(name = "SKU3")
    private String SKU3;

    /**
     * SKU3数量
     */
    @Excel(name = "SKU3数量")
    private BigDecimal SKU3Num;

    /**
     * SKU4
     */
    @Excel(name = "SKU4")
    private String SKU4;

    /**
     * SKU4数量
     */
    @Excel(name = "SKU4数量")
    private BigDecimal SKU4Num;

    /**
     * SKU5
     */
    @Excel(name = "SKU5")
    private String SKU5;

    /**
     * SKU5数量
     */
    @Excel(name = "SKU5数量")
    private BigDecimal SKU5Num;


    /**
     * 物流商
     */
    @Excel(name = "物流商")
    private String logisticsProvider;

    /**
     * 物流方式
     */
    @Excel(name = "物流方式")
    private String logisticsMethod;

    /**
     * 自有运单
     */
    @Excel(name = "自有运单")
    private String waybill;

    /**
     * 运单号
     */
    @Excel(name = "运单号")
    private String waybillNum;


    /**
     * 基础运费
     */
    @Excel(name = "基础运费")
    @NumberFormat("#0.00")
    private BigDecimal basicRate;

    /**
     * 操作附加费-超尺寸
     */
    @Excel(name = "操作附加费-超尺寸")
    @NumberFormat("#0.00")
    private BigDecimal AHSDimensions;

    /**
     * 操作附加费-超重
     */
    @Excel(name = "操作附加费-超重")
    @NumberFormat("#0.00")
    private BigDecimal AHSWeight;

    /**
     * 旺季额外附加费
     */
    @Excel(name = "旺季额外附加费")
    @NumberFormat("#0.00")
    private BigDecimal demandAHSCharge;

    /**
     * 超大超尺寸
     */
    @Excel(name = "超大超尺寸")
    @NumberFormat("#0.00")
    private BigDecimal oversizeCharge;

    /**
     * 旺季超大超尺寸附加费
     */
    @Excel(name = "旺季超大超尺寸附加费")
    @NumberFormat("#0.00")
    private BigDecimal demandOversizeSurcharge;

    /**
     * 住宅附加费
     */
    @Excel(name = "住宅附加费")
    @NumberFormat("#0.00")
    private BigDecimal residentialSurcharge;

    /**
     * 住宅旺季附加费
     */
    @Excel(name = "住宅旺季附加费")
    @NumberFormat("#0.00")
    private BigDecimal demandResidentialDeliveryCharge;

    /**
     * 包裹旺季附加费
     */
    @Excel(name = "包裹旺季附加费")
    @NumberFormat("#0.00")
    private BigDecimal demandSurcharge;


    /**
     * 偏远地区附加费1
     */
    @Excel(name = "偏远地区附加费1")
    @NumberFormat("#0.00")
    private BigDecimal DASResi;

    /**
     * 偏远地区附加费2
     */
    @Excel(name = "偏远地区附加费2")
    @NumberFormat("#0.00")
    private BigDecimal DASGround;

    /**
     * 偏远地区附加费3
     */
    @Excel(name = "偏远地区附加费3")
    @NumberFormat("#0.00")
    private BigDecimal deliveryAreaSurcharge;

    /**
     * 超偏远地区附加费1
     */
    @Excel(name = "超偏远地区附加费1")
    @NumberFormat("#0.00")
    private BigDecimal DASEXTENDEDHomeDelivery;

    /**
     * 超偏远地区附加费2
     */
    @Excel(name = "超偏远地区附加费2")
    @NumberFormat("#0.00")
    private BigDecimal DASEXTENDEDGround;

    /**
     * 超偏远地区附加费3
     */
    @Excel(name = "超偏远地区附加费3")
    @NumberFormat("#0.00")
    private BigDecimal deliveryAreaSurchargeExtended;

    /**
     * 超级偏远地区附加费1
     */
    @Excel(name = "超级偏远地区附加费1")
    @NumberFormat("#0.00")
    private BigDecimal DASRemoteComm;

    /**
     * 超级偏远地区附加费2
     */
    @Excel(name = "超级偏远地区附加费2")
    @NumberFormat("#0.00")
    private BigDecimal DASRemoteResi;

    /**
     * 超级偏远地区附加费3
     */
    @Excel(name = "超级偏远地区附加费3")
    @NumberFormat("#0.00")
    private BigDecimal deliveryAreaSurchargeRemoteResidential;


    /**
     * 签名服务费
     */
    @Excel(name = "签名服务费")
    @NumberFormat("#0.00")
    private BigDecimal indirectSignatureRequired;

    /**
     * 燃油附加费
     */
    @Excel(name = "燃油附加费")
    @NumberFormat("#0.00")
    private BigDecimal fuelSurcharge;


//    /**
//     * 操作费
//     */
//    @Excel(name = "操作费")
//    @NumberFormat("#0.00")
//    private BigDecimal operationFee;
//
//    /**
//     * 自有运单计费
//     */
//    @Excel(name = "自有运单计费")
//    @NumberFormat("#0.00")
//    private BigDecimal waybillCost;
//
//    /**
//     * Label费
//     */
//    @Excel(name = "Label费")
//    @NumberFormat("#0.00")
//    private BigDecimal labelCost;

    /**
     * 费用合计
     */
    @Excel(name = "费用合计")
    @NumberFormat("#0.00")
    private BigDecimal totalCost;

    /**
     * 客户编码
     */
    @Excel(name = "客户编码")
    private String customerNode;

    /**
     * 基础运费成本
     */
    @Excel(name = "基础运费成本")
    @NumberFormat("#0.00")
    private BigDecimal basicRateCost;

    /**
     * 操作附加费-超尺寸成本
     */
    @Excel(name = "操作附加费-超尺寸成本")
    @NumberFormat("#0.00")
    private BigDecimal AHSDimensionsCost;

    /**
     * 操作附加费-超重成本
     */
    @Excel(name = "操作附加费-超重成本")
    @NumberFormat("#0.00")
    private BigDecimal AHSWeightCost;

    /**
     * 旺季额外附加费成本
     */
    @Excel(name = "旺季额外附加费成本")
    @NumberFormat("#0.00")
    private BigDecimal demandAHSChargeCost;

    /**
     * 超大超尺寸成本
     */
    @Excel(name = "超大超尺寸成本")
    @NumberFormat("#0.00")
    private BigDecimal oversizeChargeCost;

    /**
     * 旺季超大超尺寸附加费成本
     */
    @Excel(name = "旺季超大超尺寸附加费成本")
    @NumberFormat("#0.00")
    private BigDecimal demandOversizeSurchargeCost;

    /**
     * 住宅附加费成本
     */
    @Excel(name = "住宅附加费成本")
    @NumberFormat("#0.00")
    private BigDecimal residentialSurchargeCost;

    /**
     * 住宅旺季附加费成本
     */
    @Excel(name = "住宅旺季附加费成本")
    @NumberFormat("#0.00")
    private BigDecimal demandResidentialDeliveryChargeCost;

    /**
     * 包裹旺季附加费成本
     */
    @Excel(name = "包裹旺季附加费成本")
    @NumberFormat("#0.00")
    private BigDecimal demandSurchargeCost;


    /**
     * 偏远地区附加费1成本
     */
    @Excel(name = "偏远地区附加费1成本")
    @NumberFormat("#0.00")
    private BigDecimal DASResiCost;

    /**
     * 偏远地区附加费2成本
     */
    @Excel(name = "偏远地区附加费2成本")
    @NumberFormat("#0.00")
    private BigDecimal DASGroundCost;

    /**
     * 偏远地区附加费3成本
     */
    @Excel(name = "偏远地区附加费3成本")
    @NumberFormat("#0.00")
    private BigDecimal deliveryAreaSurchargeCost;

    /**
     * ECONOMY偏远成本
     */
    @Excel(name = "ECONOMY偏远成本")
    @NumberFormat("#0.00")
    private BigDecimal DAS;


    /**
     * 超偏远地区附加费1成本
     */
    @Excel(name = "超偏远地区附加费1成本")
    @NumberFormat("#0.00")
    private BigDecimal DASEXTENDEDHomeDeliveryCost;

    /**
     * 超偏远地区附加费2成本
     */
    @Excel(name = "超偏远地区附加费2成本")
    @NumberFormat("#0.00")
    private BigDecimal DASEXTENDEDGroundCost;

    /**
     * 超偏远地区附加费3成本
     */
    @Excel(name = "超偏远地区附加费3成本")
    @NumberFormat("#0.00")
    private BigDecimal deliveryAreaSurchargeExtendedCost;

    /**
     * ECONOMY超偏远成本
     */
    @Excel(name = "ECONOMY超偏远成本")
    @NumberFormat("#0.00")
    private BigDecimal DASExtended;

    /**
     * 超级偏远地区附加费1成本
     */
    @Excel(name = "超级偏远地区附加费1成本")
    @NumberFormat("#0.00")
    private BigDecimal DASRemoteCommCost;

    /**
     * 超级偏远地区附加费2成本
     */
    @Excel(name = "超级偏远地区附加费2成本")
    @NumberFormat("#0.00")
    private BigDecimal DASRemoteResiCost;

    /**
     * 超级偏远地区附加费3成本
     */
    @Excel(name = "超级偏远地区附加费3成本")
    @NumberFormat("#0.00")
    private BigDecimal deliveryAreaSurchargeRemoteResidentialCost;


    /**
     * 签名服务费成本
     */
    @Excel(name = "签名服务费成本")
    @NumberFormat("#0.00")
    private BigDecimal indirectSignatureRequiredCost;

    /**
     * 燃油附加费成本
     */
    @Excel(name = "燃油附加费成本")
    @NumberFormat("#0.00")
    private BigDecimal fuelSurchargeCost;

    /**
     * 合计
     */
    @Excel(name = "成本合计")
    @NumberFormat("#0.00")
    private BigDecimal amountCost;

    /**
     * 销售利润率
     */
    @Excel(name = "销售利润率")
    @NumberFormat("#0.0000")
    private BigDecimal salesProfit;

    /**
     * 备注
     */
    @Excel(name = "备注")
    private String column;

}
